package young.twentyone.hwang.db;

public class Database_sql {
	static final String DB = "twentyonetodo.db";
	public static final String TWENTYONE = "twentyone";
	public static final String TODOLIST = "todolist";

	static final int DB_VERSION = 1;

	static final String CREATE_TWENTYONE = "CREATE TABLE twentyone("
			+ "to_id INTEGER PRIMARY KEY AUTOINCREMENT," + "goal TEXT,"
			+ "startdate TEXT," + "enddate TEXT, " + "gift TEXT);";

	static final String CREATE_TODOLIST = "CREATE TABLE todolist("
			+ "td_id INTEGER PRIMARY KEY AUTOINCREMENT," + "todo_name TEXT,"
			+ "date1 TEXT, check1 TEXT, status TEXT);";

	static final String DROP_TWENTYONE = "drop table twentyone;";

	static final String DROP_TODOLIST = "drop table todolist;";

}
